Pandas Profiling Report - OrderLineData

Dataset statistics

Number of variables	36
Number of observations	5000
Missing cells	8939
Missing cells (%)	5.0%
Duplicate rows	537
Duplicate rows (%)	10.7%
Total size in memory	1.4 MiB
Average record size in memory	288.0 B

Variable types

Categorical	11
Unsupported	4
DateTime	5
Numeric	15
Boolean	1

Alerts

`item_tax` has constant value "0"	Constant
`transport_cost_actual` has constant value "0"	Constant
Dataset has 537 (10.7%) duplicate rows	Duplicates
`ordoro_id` has a high cardinality: 3165 distinct values	High cardinality
`sku` has a high cardinality: 930 distinct values	High cardinality
`item_sale_price` is highly correlated with `total_per_sku` and 3 other fields	High correlation
`shipping_sale` is highly correlated with `mkp_actual_commission`	High correlation
`total_per_sku` is highly correlated with `item_sale_price` and 3 other fields	High correlation
`item_cost` is highly correlated with `item_sale_price` and 3 other fields	High correlation
`mage_mkp_commission` is highly correlated with `mkp_actual_commission`	High correlation
`mkp_estimated_commission` is highly correlated with `mkp_actual_commission`	High correlation
`mkp_actual_commission` is highly correlated with `shipping_sale` and 2 other fields	High correlation
`order_grand_total` is highly correlated with `item_sale_price` and 3 other fields	High correlation
`order_place_time` is highly correlated with `order_total_time`	High correlation
`order_total_time` is highly correlated with `order_place_time`	High correlation
`gm_estimated` is highly correlated with `item_sale_price` and 3 other fields	High correlation
`item_sale_price` is highly correlated with `total_per_sku` and 4 other fields	High correlation
`total_per_sku` is highly correlated with `item_sale_price` and 4 other fields	High correlation
`item_cost` is highly correlated with `item_sale_price` and 2 other fields	High correlation
`mkp_actual_commission` is highly correlated with `item_sale_price` and 1 other fields	High correlation
`order_grand_total` is highly correlated with `item_sale_price` and 3 other fields	High correlation
`order_place_time` is highly correlated with `order_total_time`	High correlation
`order_total_time` is highly correlated with `order_place_time`	High correlation
`gm_estimated` is highly correlated with `item_sale_price` and 2 other fields	High correlation
`item_sale_price` is highly correlated with `total_per_sku` and 3 other fields	High correlation
`total_per_sku` is highly correlated with `item_sale_price` and 3 other fields	High correlation
`item_cost` is highly correlated with `item_sale_price` and 2 other fields	High correlation
`mkp_estimated_commission` is highly correlated with `mkp_actual_commission`	High correlation
`mkp_actual_commission` is highly correlated with `mkp_estimated_commission`	High correlation
`order_grand_total` is highly correlated with `item_sale_price` and 2 other fields	High correlation
`order_place_time` is highly correlated with `order_total_time`	High correlation
`order_total_time` is highly correlated with `order_place_time`	High correlation
`gm_estimated` is highly correlated with `item_sale_price` and 1 other fields	High correlation
`supplier_name` is highly correlated with `item_tax` and 1 other fields	High correlation
`courier` is highly correlated with `item_tax` and 1 other fields	High correlation
`cd_status` is highly correlated with `item_tax` and 3 other fields	High correlation
`item_tax` is highly correlated with `supplier_name` and 8 other fields	High correlation
`transport_cost_actual` is highly correlated with `supplier_name` and 8 other fields	High correlation
`is_clogistique_order` is highly correlated with `cd_status` and 3 other fields	High correlation
`order_status` is highly correlated with `item_tax` and 2 other fields	High correlation
`line_type` is highly correlated with `item_tax` and 1 other fields	High correlation
`mkp_name` is highly correlated with `cd_status` and 3 other fields	High correlation
`line_status` is highly correlated with `item_tax` and 2 other fields	High correlation
`mkp_name` is highly correlated with `supplier_name` and 4 other fields	High correlation
`item_sale_price` is highly correlated with `shipping_sale` and 9 other fields	High correlation
`shipping_sale` is highly correlated with `item_sale_price` and 5 other fields	High correlation
`total_per_sku` is highly correlated with `item_sale_price` and 9 other fields	High correlation
`supplier_name` is highly correlated with `mkp_name` and 9 other fields	High correlation
`order_status` is highly correlated with `cancelled_value` and 7 other fields	High correlation
`item_cost` is highly correlated with `item_sale_price` and 7 other fields	High correlation
`cancelled_value` is highly correlated with `order_status` and 3 other fields	High correlation
`transport_cost_est` is highly correlated with `item_sale_price` and 8 other fields	High correlation
`courier` is highly correlated with `item_sale_price` and 3 other fields	High correlation
`mage_mkp_commission` is highly correlated with `shipping_sale` and 2 other fields	High correlation
`mkp_estimated_commission` is highly correlated with `mkp_name` and 7 other fields	High correlation
`mkp_actual_commission` is highly correlated with `item_sale_price` and 7 other fields	High correlation
`order_grand_total` is highly correlated with `item_sale_price` and 8 other fields	High correlation
`max_shipping_date` is highly correlated with `mkp_name` and 7 other fields	High correlation
`max_delivery_date` is highly correlated with `mkp_name` and 7 other fields	High correlation
`cd_status` is highly correlated with `order_status` and 6 other fields	High correlation
`is_clogistique_order` is highly correlated with `mkp_name` and 2 other fields	High correlation
`line_status` is highly correlated with `order_status` and 7 other fields	High correlation
`order_place_time` is highly correlated with `max_shipping_date` and 2 other fields	High correlation
`order_delivery_time` is highly correlated with `order_status` and 2 other fields	High correlation
`order_total_time` is highly correlated with `max_shipping_date` and 3 other fields	High correlation
`gm_estimated` is highly correlated with `item_sale_price` and 11 other fields	High correlation
`title` has 5000 (100.0%) missing values	Missing
`courier` has 1583 (31.7%) missing values	Missing
`cd_status` has 2356 (47.1%) missing values	Missing
`ordoro_id` is uniformly distributed	Uniform
`mkp_order_no` is an unsupported type, check if it needs cleaning or further analysis	Unsupported
`title` is an unsupported type, check if it needs cleaning or further analysis	Unsupported
`first_pick_date` is an unsupported type, check if it needs cleaning or further analysis	Unsupported
`last_delivery_date` is an unsupported type, check if it needs cleaning or further analysis	Unsupported
`shipping_sale` has 1963 (39.3%) zeros	Zeros
`item_cost` has 74 (1.5%) zeros	Zeros
`cancelled_value` has 4928 (98.6%) zeros	Zeros
`transport_cost_est` has 2463 (49.3%) zeros	Zeros
`mage_mkp_commission` has 3895 (77.9%) zeros	Zeros
`mkp_estimated_commission` has 2675 (53.5%) zeros	Zeros
`mkp_actual_commission` has 2356 (47.1%) zeros	Zeros
`order_place_time` has 157 (3.1%) zeros	Zeros
`order_prep_time` has 2063 (41.3%) zeros	Zeros
`order_delivery_time` has 2212 (44.2%) zeros	Zeros
`order_total_time` has 157 (3.1%) zeros	Zeros

Reproduction

Analysis started	2022-06-24 11:54:47.204783
Analysis finished	2022-06-24 11:55:37.303956
Duration	50.1 seconds
Software version	pandas-profiling v3.2.0
Download configuration	config.json

line_type
Categorical

HIGH CORRELATION

Distinct	3
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Memory size	39.2 KiB

ORDER LINE	4980
FULL REPLACEMENT	13
PARTIAL REPLACEMENT	7

Length

Max length	19
Median length	10
Mean length	10.0282
Min length	10

Characters and Unicode

Total characters	50141
Distinct characters	15
Distinct categories	2 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	ORDER LINE
2nd row	ORDER LINE
3rd row	ORDER LINE
4th row	ORDER LINE
5th row	ORDER LINE

Common Values

Value	Count	Frequency (%)
ORDER LINE	4980	99.6%
FULL REPLACEMENT	13	0.3%
PARTIAL REPLACEMENT	7	0.1%

Length

Histogram of lengths of the category

Category Frequency Plot

Value	Count	Frequency (%)
order	4980	49.8%
line	4980	49.8%
replacement	20	0.2%
full	13	0.1%
partial	7	0.1%

Most occurring characters

Value	Count	Frequency (%)
E	10020	20.0%
R	9987	19.9%
L	5033	10.0%
	5000	10.0%
N	5000	10.0%
I	4987	9.9%
O	4980	9.9%
D	4980	9.9%
A	34	0.1%
P	27	0.1%
Other values (5)	93	0.2%

Most occurring categories

Value	Count	Frequency (%)
Uppercase Letter	45141	90.0%
Space Separator	5000	10.0%

Most frequent character per category

Uppercase Letter

Value	Count	Frequency (%)
E	10020	22.2%
R	9987	22.1%
L	5033	11.1%
N	5000	11.1%
I	4987	11.0%
O	4980	11.0%
D	4980	11.0%
A	34	0.1%
P	27	0.1%
T	27	0.1%
Other values (4)	66	0.1%

Space Separator

Value	Count	Frequency (%)
	5000	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	45141	90.0%
Common	5000	10.0%

Most frequent character per script

Latin

Value	Count	Frequency (%)
E	10020	22.2%
R	9987	22.1%
L	5033	11.1%
N	5000	11.1%
I	4987	11.0%
O	4980	11.0%
D	4980	11.0%
A	34	0.1%
P	27	0.1%
T	27	0.1%
Other values (4)	66	0.1%

Common

Value	Count	Frequency (%)
	5000	100.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	50141	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
E	10020	20.0%
R	9987	19.9%
L	5033	10.0%
	5000	10.0%
N	5000	10.0%
I	4987	9.9%
O	4980	9.9%
D	4980	9.9%
A	34	0.1%
P	27	0.1%
Other values (5)	93	0.2%

mkp_name
Categorical

HIGH CORRELATION
HIGH CORRELATION

Distinct	8
Distinct (%)	0.2%
Missing	0
Missing (%)	0.0%
Memory size	39.2 KiB

CDiscount	2219
Monechelle	1516
conforama	681
CLogistique	427
Fnac	107
Other values (3)	50

Length

Max length	13
Median length	9
Mean length	9.367
Min length	4

Characters and Unicode

Total characters	46835
Distinct characters	24
Distinct categories	2 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	CDiscount
2nd row	CDiscount
3rd row	PriceMinister
4th row	Monechelle
5th row	Monechelle

Common Values

Value	Count	Frequency (%)
CDiscount	2219	44.4%
Monechelle	1516	30.3%
conforama	681	13.6%
CLogistique	427	8.5%
Fnac	107	2.1%
Darty	25	0.5%
RueDuCommerce	16	0.3%
PriceMinister	9	0.2%

Length

Histogram of lengths of the category

Category Frequency Plot

Value	Count	Frequency (%)
cdiscount	2219	44.4%
monechelle	1516	30.3%
conforama	681	13.6%
clogistique	427	8.5%
fnac	107	2.1%
darty	25	0.5%
rueducommerce	16	0.3%
priceminister	9	0.2%

Most occurring characters

Value	Count	Frequency (%)
o	5540	11.8%
e	5041	10.8%
c	4548	9.7%
n	4532	9.7%
i	3100	6.6%
l	3032	6.5%
t	2680	5.7%
u	2678	5.7%
C	2662	5.7%
s	2655	5.7%
Other values (14)	10367	22.1%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	39829	85.0%
Uppercase Letter	7006	15.0%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
o	5540	13.9%
e	5041	12.7%
c	4548	11.4%
n	4532	11.4%
i	3100	7.8%
l	3032	7.6%
t	2680	6.7%
u	2678	6.7%
s	2655	6.7%
h	1516	3.8%
Other values (7)	4507	11.3%

Uppercase Letter

Value	Count	Frequency (%)
C	2662	38.0%
D	2260	32.3%
M	1525	21.8%
L	427	6.1%
F	107	1.5%
R	16	0.2%
P	9	0.1%

Most occurring scripts

Value	Count	Frequency (%)
Latin	46835	100.0%

Most frequent character per script

Latin

Value	Count	Frequency (%)
o	5540	11.8%
e	5041	10.8%
c	4548	9.7%
n	4532	9.7%
i	3100	6.6%
l	3032	6.5%
t	2680	5.7%
u	2678	5.7%
C	2662	5.7%
s	2655	5.7%
Other values (14)	10367	22.1%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	46835	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
o	5540	11.8%
e	5041	10.8%
c	4548	9.7%
n	4532	9.7%
i	3100	6.6%
l	3032	6.5%
t	2680	5.7%
u	2678	5.7%
C	2662	5.7%
s	2655	5.7%
Other values (14)	10367	22.1%

mkp_order_no
Unsupported

REJECTED
UNSUPPORTED

Missing	0
Missing (%)	0.0%
Memory size	39.2 KiB

order_date
Date

Distinct	2928
Distinct (%)	58.6%
Missing	0
Missing (%)	0.0%
Memory size	39.2 KiB

Minimum	2020-09-08 20:30:00
Maximum	2020-10-03 09:22:00

Histogram

Histogram with fixed size bins (bins=50)

ordoro_id
Categorical

HIGH CARDINALITY
UNIFORM

Distinct	3165
Distinct (%)	63.3%
Missing	0
Missing (%)	0.0%
Memory size	39.2 KiB

1-300057096	8
1-300054839	8
1-300057378	8
1-300057368	8
1-300056841	8
Other values (3160)	4960

Length

Max length	11
Median length	11
Mean length	11
Min length	11

Characters and Unicode

Total characters	55000
Distinct characters	11
Distinct categories	2 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	1609 ?
Unique (%)	32.2%

Sample

1st row	1-300055647
2nd row	1-300055647
3rd row	1-300056586
4th row	1-300056600
5th row	1-300056647

Common Values

Value	Count	Frequency (%)
1-300057096	8	0.2%
1-300054839	8	0.2%
1-300057378	8	0.2%
1-300057368	8	0.2%
1-300056841	8	0.2%
1-300056679	8	0.2%
1-300055743	6	0.1%
1-300055781	6	0.1%
1-300055611	6	0.1%
1-300055679	6	0.1%
Other values (3155)	4928	98.6%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
1-300057096	8	0.2%
1-300057378	8	0.2%
1-300057368	8	0.2%
1-300056841	8	0.2%
1-300056679	8	0.2%
1-300054839	8	0.2%
1-300054828	6	0.1%
1-300056388	6	0.1%
1-300054843	6	0.1%
1-300057001	6	0.1%
Other values (3155)	4928	98.6%

Most occurring characters

Value	Count	Frequency (%)
0	16541	30.1%
5	7991	14.5%
1	6548	11.9%
3	6443	11.7%
-	5000	9.1%
7	3141	5.7%
6	2828	5.1%
4	1818	3.3%
8	1692	3.1%
9	1571	2.9%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	50000	90.9%
Dash Punctuation	5000	9.1%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
0	16541	33.1%
5	7991	16.0%
1	6548	13.1%
3	6443	12.9%
7	3141	6.3%
6	2828	5.7%
4	1818	3.6%
8	1692	3.4%
9	1571	3.1%
2	1427	2.9%

Dash Punctuation

Value	Count	Frequency (%)
-	5000	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	55000	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
0	16541	30.1%
5	7991	14.5%
1	6548	11.9%
3	6443	11.7%
-	5000	9.1%
7	3141	5.7%
6	2828	5.1%
4	1818	3.3%
8	1692	3.1%
9	1571	2.9%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	55000	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
0	16541	30.1%
5	7991	14.5%
1	6548	11.9%
3	6443	11.7%
-	5000	9.1%
7	3141	5.7%
6	2828	5.1%
4	1818	3.3%
8	1692	3.1%
9	1571	2.9%

sku
Categorical

HIGH CARDINALITY

Distinct	930
Distinct (%)	18.6%
Missing	0
Missing (%)	0.0%
Memory size	39.2 KiB

TOP-MalwaM6/140/white	366
TOP-MalwaM3/white	143
AKO-K120-6SZ-BIALA	108
TOP-MalwaM6/140/sonoma	93
AKO-K60-5SZ-BIALA	83
Other values (925)	4207

Length

Max length	50
Median length	43
Mean length	20.2334
Min length	7

Characters and Unicode

Total characters	101167
Distinct characters	67
Distinct categories	7 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	279 ?
Unique (%)	5.6%

Sample

1st row	KK-KKLJOYBLU00000
2nd row	KK-KKLJOYBLU00000
3rd row	KK-KKWMOOVNAV0000
4th row	KK-KKLJOYBLU000AC
5th row	KK-KKLJOYBLU000AC

Common Values

Value	Count	Frequency (%)
TOP-MalwaM6/140/white	366	7.3%
TOP-MalwaM3/white	143	2.9%
AKO-K120-6SZ-BIALA	108	2.2%
TOP-MalwaM6/140/sonoma	93	1.9%
AKO-K60-5SZ-BIALA	83	1.7%
AKO-K120-8SZ-BIALA	78	1.6%
TOP-S33/sonoma	78	1.6%
TOP-2D4S/120/dab_artisan	71	1.4%
TOP-S33/white	71	1.4%
TOP-MalwaM4/white	56	1.1%
Other values (920)	3853	77.1%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
top-malwam6/140/white	366	7.1%
top-malwam3/white	143	2.8%
ako-k120-6sz-biala	108	2.1%
top-malwam6/140/sonoma	93	1.8%
ako-k60-5sz-biala	83	1.6%
ako-k120-8sz-biala	78	1.5%
top-s33/sonoma	78	1.5%
top-2d4s/120/dab_artisan	71	1.4%
top-s33/white	71	1.4%
top-malwam2/white	59	1.2%
Other values (921)	3973	77.6%

Most occurring characters

Value	Count	Frequency (%)
-	11974	11.8%
O	5810	5.7%
A	5108	5.0%
a	4573	4.5%
M	3611	3.6%
P	3385	3.3%
K	3233	3.2%
0	3231	3.2%
T	3231	3.2%
/	2934	2.9%
Other values (57)	54077	53.5%

Most occurring categories

Value	Count	Frequency (%)
Uppercase Letter	44649	44.1%
Lowercase Letter	27356	27.0%
Decimal Number	13791	13.6%
Dash Punctuation	11974	11.8%
Other Punctuation	3018	3.0%
Connector Punctuation	256	0.3%
Space Separator	123	0.1%

Most frequent character per category

Uppercase Letter

Value	Count	Frequency (%)
O	5810	13.0%
A	5108	11.4%
M	3611	8.1%
P	3385	7.6%
K	3233	7.2%
T	3231	7.2%
S	2616	5.9%
L	2223	5.0%
B	2217	5.0%
I	1838	4.1%
Other values (16)	11377	25.5%

Lowercase Letter

Value	Count	Frequency (%)
a	4573	16.7%
e	2520	9.2%
i	2295	8.4%
w	2280	8.3%
o	2260	8.3%
t	1992	7.3%
l	1815	6.6%
n	1657	6.1%
h	1585	5.8%
s	1209	4.4%
Other values (16)	5170	18.9%

Decimal Number

Value	Count	Frequency (%)
0	3231	23.4%
1	2655	19.3%
2	1725	12.5%
4	1620	11.7%
6	1545	11.2%
3	1351	9.8%
5	643	4.7%
8	518	3.8%
7	277	2.0%
9	226	1.6%

Other Punctuation

Value	Count	Frequency (%)
/	2934	97.2%
.	84	2.8%

Dash Punctuation

Value	Count	Frequency (%)
-	11974	100.0%

Connector Punctuation

Value	Count	Frequency (%)
_	256	100.0%

Space Separator

Value	Count	Frequency (%)
	123	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	72005	71.2%
Common	29162	28.8%

Most frequent character per script

Latin

Value	Count	Frequency (%)
O	5810	8.1%
A	5108	7.1%
a	4573	6.4%
M	3611	5.0%
P	3385	4.7%
K	3233	4.5%
T	3231	4.5%
S	2616	3.6%
e	2520	3.5%
i	2295	3.2%
Other values (42)	35623	49.5%

Common

Value	Count	Frequency (%)
-	11974	41.1%
0	3231	11.1%
/	2934	10.1%
1	2655	9.1%
2	1725	5.9%
4	1620	5.6%
6	1545	5.3%
3	1351	4.6%
5	643	2.2%
8	518	1.8%
Other values (5)	966	3.3%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	101167	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
-	11974	11.8%
O	5810	5.7%
A	5108	5.0%
a	4573	4.5%
M	3611	3.6%
P	3385	3.3%
K	3233	3.2%
0	3231	3.2%
T	3231	3.2%
/	2934	2.9%
Other values (57)	54077	53.5%

item_sale_price
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION

Distinct	257
Distinct (%)	5.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	126.089582

Minimum	0
Maximum	869.95
Zeros	14
Zeros (%)	0.3%
Negative	0
Negative (%)	0.0%
Memory size	39.2 KiB

Quantile statistics

Minimum	0
5-th percentile	44.95
Q1	77.95
median	99.95
Q3	139.95
95-th percentile	259.95
Maximum	869.95
Range	869.95
Interquartile range (IQR)	62

Descriptive statistics

Standard deviation	94.96599609
Coefficient of variation (CV)	0.7531629068
Kurtosis	17.02785374
Mean	126.089582
Median Absolute Deviation (MAD)	30
Skewness	3.629804934
Sum	630447.91
Variance	9018.540414
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
89.95	563	11.3%
99.95	218	4.4%
74.95	214	4.3%
79.95	195	3.9%
114.95	167	3.3%
119.95	164	3.3%
134.95	141	2.8%
139.95	135	2.7%
39.95	123	2.5%
109.95	120	2.4%
Other values (247)	2960	59.2%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	14	0.3%
9.9	2	< 0.1%
12.95	1	< 0.1%
16.95	2	< 0.1%
19.95	1	< 0.1%
22.9	1	< 0.1%
22.95	5	0.1%
24.95	2	< 0.1%
26.95	1	< 0.1%
29.05	1	< 0.1%

Value	Count	Frequency (%)
869.95	3	0.1%
829.95	1	< 0.1%
759.95	3	0.1%
757.95	2	< 0.1%
751.95	2	< 0.1%
744.95	1	< 0.1%
708.95	2	< 0.1%
706.95	2	< 0.1%
699.95	7	0.1%
688.95	2	< 0.1%

item_tax
Categorical

CONSTANT
HIGH CORRELATION
REJECTED

Distinct	1
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	39.2 KiB

0	5000

Length

Max length	1
Median length	1
Mean length	1
Min length	1

Characters and Unicode

Total characters	5000
Distinct characters	1
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	0
2nd row	0
3rd row	0
4th row	0
5th row	0

Common Values

Value	Count	Frequency (%)
0	5000	100.0%

Length

Histogram of lengths of the category

Category Frequency Plot

Value	Count	Frequency (%)
0	5000	100.0%

Most occurring characters

Value	Count	Frequency (%)
0	5000	100.0%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	5000	100.0%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
0	5000	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	5000	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
0	5000	100.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	5000	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
0	5000	100.0%

shipping_sale
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
ZEROS

Distinct	30
Distinct (%)	0.6%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	9.743202

Minimum	0
Maximum	100
Zeros	1963
Zeros (%)	39.3%
Negative	0
Negative (%)	0.0%
Memory size	39.2 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	9.95
Q3	19.95
95-th percentile	19.95
Maximum	100
Range	100
Interquartile range (IQR)	19.95

Descriptive statistics

Standard deviation	9.026153024
Coefficient of variation (CV)	0.9264052027
Kurtosis	0.8130880075
Mean	9.743202
Median Absolute Deviation (MAD)	9.95
Skewness	0.4013176443
Sum	48716.01
Variance	81.47143841
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=30)

Value	Count	Frequency (%)
0	1963	39.3%
19.95	1801	36.0%
9.95	973	19.5%
4.98	62	1.2%
12.48	44	0.9%
14.95	20	0.4%
9.99	16	0.3%
19.99	16	0.3%
3.99	13	0.3%
9.98	12	0.2%
Other values (20)	80	1.6%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	1963	39.3%
0.97	2	< 0.1%
1.2	2	< 0.1%
1.27	1	< 0.1%
1.5	6	0.1%
2.07	2	< 0.1%
2.71	1	< 0.1%
2.99	5	0.1%
3.32	3	0.1%
3.5	2	< 0.1%

Value	Count	Frequency (%)
100	1	< 0.1%
50	2	< 0.1%
49.95	4	0.1%
39.95	5	0.1%
34.95	6	0.1%
24.95	4	0.1%
19.99	16	0.3%
19.95	1801	36.0%
14.98	2	< 0.1%
14.95	20	0.4%

total_per_sku
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION

Distinct	426
Distinct (%)	8.5%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	135.832784

Minimum	0
Maximum	919.9
Zeros	9
Zeros (%)	0.2%
Negative	0
Negative (%)	0.0%
Memory size	39.2 KiB

Quantile statistics

Minimum	0
5-th percentile	49.95
Q1	79.95
median	109.9
Q3	151.995
95-th percentile	269.9015
Maximum	919.9
Range	919.9
Interquartile range (IQR)	72.045

Descriptive statistics

Standard deviation	96.76917272
Coefficient of variation (CV)	0.7124139686
Kurtosis	16.50259543
Mean	135.832784
Median Absolute Deviation (MAD)	31.95
Skewness	3.527433161
Sum	679163.92
Variance	9364.272788
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
109.9	343	6.9%
74.95	167	3.3%
134.9	141	2.8%
99.9	117	2.3%
89.95	109	2.2%
139.9	109	2.2%
99.95	103	2.1%
77.95	102	2.0%
89.9	101	2.0%
79.95	92	1.8%
Other values (416)	3616	72.3%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	9	0.2%
9.99	4	0.1%
19.85	2	< 0.1%
19.95	1	< 0.1%
22.9	1	< 0.1%
24.95	2	< 0.1%
29.9	1	< 0.1%
29.95	3	0.1%
32.85	1	< 0.1%
32.9	5	0.1%

Value	Count	Frequency (%)
919.9	2	< 0.1%
889.9	1	< 0.1%
849.9	1	< 0.1%
779.9	3	0.1%
777.9	2	< 0.1%
764.9	1	< 0.1%
751.95	2	< 0.1%
728.9	2	< 0.1%
719.9	6	0.1%
706.95	2	< 0.1%

title
Unsupported

MISSING
REJECTED
UNSUPPORTED

Missing	5000
Missing (%)	100.0%
Memory size	39.2 KiB

supplier_name
Categorical

HIGH CORRELATION
HIGH CORRELATION

Distinct	37
Distinct (%)	0.7%
Missing	0
Missing (%)	0.0%
Memory size	39.2 KiB

TOP	2408
AKO	1234
MOB	412
KD	169
HAA	79
Other values (32)	698

Length

Max length	5
Median length	3
Mean length	2.9842
Min length	2

Characters and Unicode

Total characters	14921
Distinct characters	22
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	3 ?
Unique (%)	0.1%

Sample

1st row	KK
2nd row	KK
3rd row	KK
4th row	KK
5th row	KK

Common Values

Value	Count	Frequency (%)
TOP	2408	48.2%
AKO	1234	24.7%
MOB	412	8.2%
KD	169	3.4%
HAA	79	1.6%
MAL	72	1.4%
REG	71	1.4%
BEL	68	1.4%
CARE	65	1.3%
PM	50	1.0%
Other values (27)	372	7.4%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
top	2408	48.2%
ako	1234	24.7%
mob	412	8.2%
kd	169	3.4%
haa	79	1.6%
mal	72	1.4%
reg	71	1.4%
bel	68	1.4%
care	65	1.3%
pm	50	1.0%
Other values (27)	372	7.4%

Most occurring characters

Value	Count	Frequency (%)
O	4180	28.0%
P	2459	16.5%
T	2448	16.4%
A	1545	10.4%
K	1463	9.8%
M	622	4.2%
B	530	3.6%
E	224	1.5%
D	208	1.4%
L	176	1.2%
Other values (12)	1066	7.1%

Most occurring categories

Value	Count	Frequency (%)
Uppercase Letter	14921	100.0%

Most frequent character per category

Uppercase Letter

Value	Count	Frequency (%)
O	4180	28.0%
P	2459	16.5%
T	2448	16.4%
A	1545	10.4%
K	1463	9.8%
M	622	4.2%
B	530	3.6%
E	224	1.5%
D	208	1.4%
L	176	1.2%
Other values (12)	1066	7.1%

Most occurring scripts

Value	Count	Frequency (%)
Latin	14921	100.0%

Most frequent character per script

Latin

Value	Count	Frequency (%)
O	4180	28.0%
P	2459	16.5%
T	2448	16.4%
A	1545	10.4%
K	1463	9.8%
M	622	4.2%
B	530	3.6%
E	224	1.5%
D	208	1.4%
L	176	1.2%
Other values (12)	1066	7.1%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	14921	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
O	4180	28.0%
P	2459	16.5%
T	2448	16.4%
A	1545	10.4%
K	1463	9.8%
M	622	4.2%
B	530	3.6%
E	224	1.5%
D	208	1.4%
L	176	1.2%
Other values (12)	1066	7.1%

order_status
Categorical

HIGH CORRELATION
HIGH CORRELATION

Distinct	3
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Memory size	39.2 KiB

shipped	3551
awaiting_fulfillment	1377
cancelled	72

Length

Max length	20
Median length	7
Mean length	10.609
Min length	7

Characters and Unicode

Total characters	53045
Distinct characters	17
Distinct categories	2 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	shipped
2nd row	shipped
3rd row	shipped
4th row	shipped
5th row	shipped

Common Values

Value	Count	Frequency (%)
shipped	3551	71.0%
awaiting_fulfillment	1377	27.5%
cancelled	72	1.4%

Length

Histogram of lengths of the category

Category Frequency Plot

Value	Count	Frequency (%)
shipped	3551	71.0%
awaiting_fulfillment	1377	27.5%
cancelled	72	1.4%

Most occurring characters

Value	Count	Frequency (%)
i	7682	14.5%
p	7102	13.4%
e	5072	9.6%
l	4275	8.1%
d	3623	6.8%
s	3551	6.7%
h	3551	6.7%
a	2826	5.3%
n	2826	5.3%
f	2754	5.2%
Other values (7)	9783	18.4%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	51668	97.4%
Connector Punctuation	1377	2.6%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
i	7682	14.9%
p	7102	13.7%
e	5072	9.8%
l	4275	8.3%
d	3623	7.0%
s	3551	6.9%
h	3551	6.9%
a	2826	5.5%
n	2826	5.5%
f	2754	5.3%
Other values (6)	8406	16.3%

Connector Punctuation

Value	Count	Frequency (%)
_	1377	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	51668	97.4%
Common	1377	2.6%

Most frequent character per script

Latin

Value	Count	Frequency (%)
i	7682	14.9%
p	7102	13.7%
e	5072	9.8%
l	4275	8.3%
d	3623	7.0%
s	3551	6.9%
h	3551	6.9%
a	2826	5.5%
n	2826	5.5%
f	2754	5.3%
Other values (6)	8406	16.3%

Common

Value	Count	Frequency (%)
_	1377	100.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	53045	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
i	7682	14.5%
p	7102	13.4%
e	5072	9.6%
l	4275	8.1%
d	3623	6.8%
s	3551	6.7%
h	3551	6.7%
a	2826	5.3%
n	2826	5.3%
f	2754	5.2%
Other values (7)	9783	18.4%

item_cost
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
ZEROS

Distinct	462
Distinct (%)	9.2%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	42.622798

Minimum	0
Maximum	333.78
Zeros	74
Zeros (%)	1.5%
Negative	0
Negative (%)	0.0%
Memory size	39.2 KiB

Quantile statistics

Minimum	0
5-th percentile	13.78
Q1	24.87
median	39.08
Q3	50.97
95-th percentile	89.53
Maximum	333.78
Range	333.78
Interquartile range (IQR)	26.1

Descriptive statistics

Standard deviation	28.9859361
Coefficient of variation (CV)	0.6800570929
Kurtosis	17.6382357
Mean	42.622798
Median Absolute Deviation (MAD)	13.32
Skewness	3.363337706
Sum	213113.99
Variance	840.1844914
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
43.95	510	10.2%
24.87	226	4.5%
23.98	178	3.6%
24.33	136	2.7%
39.16	125	2.5%
35.59	119	2.4%
12.17	110	2.2%
30.24	109	2.2%
65.99	103	2.1%
50.97	103	2.1%
Other values (452)	3281	65.6%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	74	1.5%
0.99	1	< 0.1%
4.53	2	< 0.1%
4.7	1	< 0.1%
5.1	2	< 0.1%
6.46	1	< 0.1%
6.49	2	< 0.1%
7.65	5	0.1%
7.99	3	0.1%
8.71	6	0.1%

Value	Count	Frequency (%)
333.78	1	< 0.1%
303.12	1	< 0.1%
264.4	1	< 0.1%
259.12	2	< 0.1%
256.89	2	< 0.1%
242.54	2	< 0.1%
231	2	< 0.1%
221.05	1	< 0.1%
216.45	7	0.1%
214.86	6	0.1%

cancelled_value
Real number (ℝ_≥0)

HIGH CORRELATION
ZEROS

Distinct	44
Distinct (%)	0.9%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	2.016876

Minimum	0
Maximum	741.58
Zeros	4928
Zeros (%)	98.6%
Negative	0
Negative (%)	0.0%
Memory size	39.2 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	0
95-th percentile	0
Maximum	741.58
Range	741.58
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	21.07987649
Coefficient of variation (CV)	10.45174641
Kurtosis	432.6065269
Mean	2.016876
Median Absolute Deviation (MAD)	0
Skewness	17.3687368
Sum	10084.38
Variance	444.3611927
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=44)

Value	Count	Frequency (%)
0	4928	98.6%
105.75	4	0.1%
166.63	4	0.1%
149.92	4	0.1%
112.46	2	< 0.1%
138.18	2	< 0.1%
73.13	2	< 0.1%
109.72	2	< 0.1%
299.92	2	< 0.1%
65.75	2	< 0.1%
Other values (34)	48	1.0%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	4928	98.6%
27.38	1	< 0.1%
42.41	2	< 0.1%
43.21	1	< 0.1%
46.28	1	< 0.1%
49.96	1	< 0.1%
58.25	2	< 0.1%
62.42	2	< 0.1%
63.25	2	< 0.1%
65.75	2	< 0.1%

Value	Count	Frequency (%)
741.58	1	< 0.1%
499.92	1	< 0.1%
340.71	2	< 0.1%
299.92	2	< 0.1%
283.25	1	< 0.1%
214.88	2	< 0.1%
191.63	2	< 0.1%
183.25	1	< 0.1%
166.63	4	0.1%
162.42	2	< 0.1%

transport_cost_est
Real number (ℝ_≥0)

HIGH CORRELATION
ZEROS

Distinct	62
Distinct (%)	1.2%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	11.465766

Minimum	0
Maximum	177.89
Zeros	2463
Zeros (%)	49.3%
Negative	0
Negative (%)	0.0%
Memory size	39.2 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	11.32
Q3	16
95-th percentile	31.9
Maximum	177.89
Range	177.89
Interquartile range (IQR)	16

Descriptive statistics

Standard deviation	16.1640651
Coefficient of variation (CV)	1.409767572
Kurtosis	26.91198677
Mean	11.465766
Median Absolute Deviation (MAD)	11.32
Skewness	3.74214941
Sum	57328.83
Variance	261.2770005
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	2463	49.3%
16	855	17.1%
15.95	613	12.3%
29.61	282	5.6%
31.9	201	4.0%
35.85	88	1.8%
30.86	60	1.2%
11.32	46	0.9%
11.7	41	0.8%
13.9	25	0.5%
Other values (52)	326	6.5%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	2463	49.3%
9.05	8	0.2%
10.07	3	0.1%
10.81	2	< 0.1%
11.31	16	0.3%
11.32	46	0.9%
11.7	41	0.8%
11.79	2	< 0.1%
12.29	4	0.1%
12.84	15	0.3%

Value	Count	Frequency (%)
177.89	8	0.2%
145	3	0.1%
114.03	17	0.3%
99.83	8	0.2%
89.54	7	0.1%
87.75	2	< 0.1%
83.7	2	< 0.1%
71.7	1	< 0.1%
67.75	13	0.3%
52.52	1	< 0.1%

first_pick_date
Unsupported

REJECTED
UNSUPPORTED

Missing	0
Missing (%)	0.0%
Memory size	39.2 KiB

last_delivery_date
Unsupported

REJECTED
UNSUPPORTED

Missing	0
Missing (%)	0.0%
Memory size	39.2 KiB

courier
Categorical

HIGH CORRELATION
HIGH CORRELATION
MISSING

Distinct	2
Distinct (%)	0.1%
Missing	1583
Missing (%)	31.7%
Memory size	39.2 KiB

UPS	1927
DPD	1490

Length

Max length	3
Median length	3
Mean length	3
Min length	3

Characters and Unicode

Total characters	10251
Distinct characters	4
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	UPS
2nd row	UPS
3rd row	DPD
4th row	DPD
5th row	UPS

Common Values

Value	Count	Frequency (%)
UPS	1927	38.5%
DPD	1490	29.8%
(Missing)	1583	31.7%

Length

Histogram of lengths of the category

Category Frequency Plot

Value	Count	Frequency (%)
ups	1927	56.4%
dpd	1490	43.6%

Most occurring characters

Value	Count	Frequency (%)
P	3417	33.3%
D	2980	29.1%
U	1927	18.8%
S	1927	18.8%

Most occurring categories

Value	Count	Frequency (%)
Uppercase Letter	10251	100.0%

Most frequent character per category

Uppercase Letter

Value	Count	Frequency (%)
P	3417	33.3%
D	2980	29.1%
U	1927	18.8%
S	1927	18.8%

Most occurring scripts

Value	Count	Frequency (%)
Latin	10251	100.0%

Most frequent character per script

Latin

Value	Count	Frequency (%)
P	3417	33.3%
D	2980	29.1%
U	1927	18.8%
S	1927	18.8%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	10251	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
P	3417	33.3%
D	2980	29.1%
U	1927	18.8%
S	1927	18.8%

mage_mkp_commission
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
ZEROS

Distinct	202
Distinct (%)	4.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	0.899702

Minimum	0
Maximum	92.34
Zeros	3895
Zeros (%)	77.9%
Negative	0
Negative (%)	0.0%
Memory size	39.2 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	0
95-th percentile	3.72
Maximum	92.34
Range	92.34
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	3.954292531
Coefficient of variation (CV)	4.395113638
Kurtosis	300.005005
Mean	0.899702
Median Absolute Deviation (MAD)	0
Skewness	15.48905634
Sum	4498.51
Variance	15.63642942
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	3895	77.9%
2.64	107	2.1%
3.24	44	0.9%
1.8	44	0.9%
1.87	33	0.7%
2.88	32	0.6%
3.36	31	0.6%
2.4	31	0.6%
1.92	31	0.6%
2.63	26	0.5%
Other values (192)	726	14.5%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	3895	77.9%
0.78	1	< 0.1%
0.79	2	< 0.1%
0.86	4	0.1%
0.89	1	< 0.1%
0.95	1	< 0.1%
0.96	19	0.4%
1	4	0.1%
1.03	1	< 0.1%
1.04	2	< 0.1%

Value	Count	Frequency (%)
92.34	2	< 0.1%
77.95	2	< 0.1%
76.75	1	< 0.1%
74.95	4	0.1%
30	6	0.1%
27.12	1	< 0.1%
17.48	2	< 0.1%
17.28	1	< 0.1%
16.97	4	0.1%
16.7	2	< 0.1%

mkp_estimated_commission
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
ZEROS

Distinct	237
Distinct (%)	4.7%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	9.738542

Minimum	0
Maximum	141.09
Zeros	2675
Zeros (%)	53.5%
Negative	0
Negative (%)	0.0%
Memory size	39.2 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	17.24
95-th percentile	30.59
Maximum	141.09
Range	141.09
Interquartile range (IQR)	17.24

Descriptive statistics

Standard deviation	14.05669497
Coefficient of variation (CV)	1.443408569
Kurtosis	11.34607209
Mean	9.738542
Median Absolute Deviation (MAD)	0
Skewness	2.566373589
Sum	48692.71
Variance	197.5906734
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	2675	53.5%
20.24	93	1.9%
13.49	86	1.7%
14.99	78	1.6%
20.99	77	1.5%
11.99	68	1.4%
17.99	56	1.1%
15.29	50	1.0%
11.54	48	1.0%
22.09	47	0.9%
Other values (227)	1722	34.4%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	2675	53.5%
2.54	2	< 0.1%
3.74	2	< 0.1%
4.49	3	0.1%
4.79	2	< 0.1%
4.94	2	< 0.1%
5.09	18	0.4%
5.24	2	< 0.1%
5.43	1	< 0.1%
5.94	8	0.2%

Value	Count	Frequency (%)
141.09	1	< 0.1%
112.79	2	< 0.1%
106.04	2	< 0.1%
104.99	1	< 0.1%
103.34	2	< 0.1%
102.84	1	< 0.1%
101.82	1	< 0.1%
99.74	1	< 0.1%
95.99	3	0.1%
93.74	6	0.1%

mkp_actual_commission
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
ZEROS

Distinct	486
Distinct (%)	9.7%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	9.56719

Minimum	0
Maximum	155.09
Zeros	2356
Zeros (%)	47.1%
Negative	0
Negative (%)	0.0%
Memory size	39.2 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	5.49
Q3	13.5175
95-th percentile	32.98
Maximum	155.09
Range	155.09
Interquartile range (IQR)	13.5175

Descriptive statistics

Standard deviation	15.30695413
Coefficient of variation (CV)	1.599942525
Kurtosis	19.42986013
Mean	9.56719
Median Absolute Deviation (MAD)	5.49
Skewness	3.585909704
Sum	47835.95
Variance	234.3028447
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	2356	47.1%
5.49	105	2.1%
5.99	77	1.5%
8.13	65	1.3%
11.83	51	1.0%
6.23	48	1.0%
8.79	47	0.9%
5.59	40	0.8%
11.43	36	0.7%
13.48	36	0.7%
Other values (476)	2139	42.8%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	2356	47.1%
2.97	2	< 0.1%
3.19	18	0.4%
3.2	6	0.1%
3.43	1	< 0.1%
3.99	5	0.1%
4	4	0.1%
4.06	4	0.1%
4.15	3	0.1%
4.16	10	0.2%

Value	Count	Frequency (%)
155.09	2	< 0.1%
133.48	1	< 0.1%
126.81	2	< 0.1%
125.26	1	< 0.1%
123	4	0.1%
121.08	2	< 0.1%
120.17	1	< 0.1%
116.98	3	0.1%
115.69	1	< 0.1%
114.73	1	< 0.1%

order_grand_total
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION

Distinct	694
Distinct (%)	13.9%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	161.364346

Minimum	19.85
Maximum	1309.9
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	39.2 KiB

Quantile statistics

Minimum	19.85
5-th percentile	67.9
Q1	89.85
median	129.9
Q3	186.95
95-th percentile	384.85
Maximum	1309.9
Range	1290.05
Interquartile range (IQR)	97.1

Descriptive statistics

Standard deviation	129.3543294
Coefficient of variation (CV)	0.8016289387
Kurtosis	19.73849868
Mean	161.364346
Median Absolute Deviation (MAD)	45
Skewness	3.728411865
Sum	806821.73
Variance	16732.54254
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
109.9	174	3.5%
89.95	96	1.9%
99.95	85	1.7%
89.9	79	1.6%
112.54	78	1.6%
134.95	78	1.6%
74.95	77	1.5%
99.9	77	1.5%
79.9	69	1.4%
149.9	67	1.3%
Other values (684)	4120	82.4%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
19.85	2	< 0.1%
22.9	1	< 0.1%
24.95	2	< 0.1%
29.9	1	< 0.1%
29.95	3	0.1%
32.85	1	< 0.1%
32.9	2	< 0.1%
33.68	1	< 0.1%
33.69	2	< 0.1%
34.95	2	< 0.1%

Value	Count	Frequency (%)
1309.9	2	< 0.1%
1174.55	8	0.2%
1146.9	4	0.1%
1059.9	2	< 0.1%
1057.6	8	0.2%
911.51	2	< 0.1%
889.9	1	< 0.1%
879.8	2	< 0.1%
849.9	1	< 0.1%
822.85	2	< 0.1%

ordoro_import_date
Date

Distinct	467
Distinct (%)	9.3%
Missing	0
Missing (%)	0.0%
Memory size	39.2 KiB

Minimum	2020-09-08 23:24:00
Maximum	2020-10-03 11:40:00

Histogram

Histogram with fixed size bins (bins=50)

tool_import_date
Date

Distinct	395
Distinct (%)	7.9%
Missing	0
Missing (%)	0.0%
Memory size	39.2 KiB

Minimum	2020-09-08 23:30:00
Maximum	2020-10-03 11:45:00

Histogram

Histogram with fixed size bins (bins=50)

max_shipping_date
Date

HIGH CORRELATION

Distinct	49
Distinct (%)	1.0%
Missing	0
Missing (%)	0.0%
Memory size	39.2 KiB

Minimum	2020-09-09 00:00:00
Maximum	2020-11-20 00:00:00

Histogram

Histogram with fixed size bins (bins=49)

max_delivery_date
Date

HIGH CORRELATION

Distinct	58
Distinct (%)	1.2%
Missing	0
Missing (%)	0.0%
Memory size	39.2 KiB

Minimum	2020-09-11 00:00:00
Maximum	2020-12-01 00:00:00

Histogram

Histogram with fixed size bins (bins=50)

cd_status
Categorical

HIGH CORRELATION
HIGH CORRELATION
MISSING

Distinct	3
Distinct (%)	0.1%
Missing	2356
Missing (%)	47.1%
Memory size	39.2 KiB

WaitingForShipmentAcceptation	2143
Shipped	468
CancelledByCustomer	33

Length

Max length	29
Median length	29
Mean length	24.98108926
Min length	7

Characters and Unicode

Total characters	66050
Distinct characters	23
Distinct categories	2 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	WaitingForShipmentAcceptation
2nd row	WaitingForShipmentAcceptation
3rd row	WaitingForShipmentAcceptation
4th row	WaitingForShipmentAcceptation
5th row	WaitingForShipmentAcceptation

Common Values

Value	Count	Frequency (%)
WaitingForShipmentAcceptation	2143	42.9%
Shipped	468	9.4%
CancelledByCustomer	33	0.7%
(Missing)	2356	47.1%

Length

Histogram of lengths of the category

Category Frequency Plot

Value	Count	Frequency (%)
waitingforshipmentacceptation	2143	81.1%
shipped	468	17.7%
cancelledbycustomer	33	1.2%

Most occurring characters

Value	Count	Frequency (%)
i	9040	13.7%
t	8605	13.0%
n	6462	9.8%
p	5222	7.9%
e	4853	7.3%
c	4319	6.5%
o	4319	6.5%
a	4319	6.5%
S	2611	4.0%
h	2611	4.0%
Other values (13)	13689	20.7%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	56911	86.2%
Uppercase Letter	9139	13.8%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
i	9040	15.9%
t	8605	15.1%
n	6462	11.4%
p	5222	9.2%
e	4853	8.5%
c	4319	7.6%
o	4319	7.6%
a	4319	7.6%
h	2611	4.6%
r	2176	3.8%
Other values (7)	4985	8.8%

Uppercase Letter

Value	Count	Frequency (%)
S	2611	28.6%
A	2143	23.4%
W	2143	23.4%
F	2143	23.4%
C	66	0.7%
B	33	0.4%

Most occurring scripts

Value	Count	Frequency (%)
Latin	66050	100.0%

Most frequent character per script

Latin

Value	Count	Frequency (%)
i	9040	13.7%
t	8605	13.0%
n	6462	9.8%
p	5222	7.9%
e	4853	7.3%
c	4319	6.5%
o	4319	6.5%
a	4319	6.5%
S	2611	4.0%
h	2611	4.0%
Other values (13)	13689	20.7%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	66050	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
i	9040	13.7%
t	8605	13.0%
n	6462	9.8%
p	5222	7.9%
e	4853	7.3%
c	4319	6.5%
o	4319	6.5%
a	4319	6.5%
S	2611	4.0%
h	2611	4.0%
Other values (13)	13689	20.7%

is_clogistique_order
Boolean

HIGH CORRELATION
HIGH CORRELATION

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	5.0 KiB

False	4573
True	427

Common Values
Category Frequency Plot

Value	Count	Frequency (%)
False	4573	91.5%
True	427	8.5%

line_status
Categorical

HIGH CORRELATION
HIGH CORRELATION

Distinct	3
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Memory size	39.2 KiB

Awaiting shipment	3531
Awaiting Protocol	1397
Cancelled	72

Length

Max length	17
Median length	17
Mean length	16.8848
Min length	9

Characters and Unicode

Total characters	84424
Distinct characters	20
Distinct categories	3 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Awaiting shipment
2nd row	Awaiting shipment
3rd row	Awaiting shipment
4th row	Awaiting shipment
5th row	Awaiting shipment

Common Values

Value	Count	Frequency (%)
Awaiting shipment	3531	70.6%
Awaiting Protocol	1397	27.9%
Cancelled	72	1.4%

Length

Histogram of lengths of the category

Category Frequency Plot

Value	Count	Frequency (%)
awaiting	4928	49.6%
shipment	3531	35.6%
protocol	1397	14.1%
cancelled	72	0.7%

Most occurring characters

Value	Count	Frequency (%)
i	13387	15.9%
t	9856	11.7%
n	8531	10.1%
a	5000	5.9%
A	4928	5.8%
g	4928	5.8%
	4928	5.8%
w	4928	5.8%
o	4191	5.0%
e	3675	4.4%
Other values (10)	20072	23.8%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	73099	86.6%
Uppercase Letter	6397	7.6%
Space Separator	4928	5.8%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
i	13387	18.3%
t	9856	13.5%
n	8531	11.7%
a	5000	6.8%
g	4928	6.7%
w	4928	6.7%
o	4191	5.7%
e	3675	5.0%
m	3531	4.8%
p	3531	4.8%
Other values (6)	11541	15.8%

Uppercase Letter

Value	Count	Frequency (%)
A	4928	77.0%
P	1397	21.8%
C	72	1.1%

Space Separator

Value	Count	Frequency (%)
	4928	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	79496	94.2%
Common	4928	5.8%

Most frequent character per script

Latin

Value	Count	Frequency (%)
i	13387	16.8%
t	9856	12.4%
n	8531	10.7%
a	5000	6.3%
A	4928	6.2%
g	4928	6.2%
w	4928	6.2%
o	4191	5.3%
e	3675	4.6%
m	3531	4.4%
Other values (9)	16541	20.8%

Common

Value	Count	Frequency (%)
	4928	100.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	84424	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
i	13387	15.9%
t	9856	11.7%
n	8531	10.1%
a	5000	5.9%
A	4928	5.8%
g	4928	5.8%
	4928	5.8%
w	4928	5.8%
o	4191	5.0%
e	3675	4.4%
Other values (10)	20072	23.8%

transport_cost_actual
Categorical

CONSTANT
HIGH CORRELATION
REJECTED

Distinct	1
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	39.2 KiB

0	5000

Length

Max length	1
Median length	1
Mean length	1
Min length	1

Characters and Unicode

Total characters	5000
Distinct characters	1
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	0
2nd row	0
3rd row	0
4th row	0
5th row	0

Common Values

Value	Count	Frequency (%)
0	5000	100.0%

Length

Histogram of lengths of the category

Category Frequency Plot

Value	Count	Frequency (%)
0	5000	100.0%

Most occurring characters

Value	Count	Frequency (%)
0	5000	100.0%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	5000	100.0%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
0	5000	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	5000	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
0	5000	100.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	5000	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
0	5000	100.0%

order_place_time
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
ZEROS

Distinct	25
Distinct (%)	0.5%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	7.054

Minimum	0
Maximum	24
Zeros	157
Zeros (%)	3.1%
Negative	0
Negative (%)	0.0%
Memory size	39.2 KiB

Quantile statistics

Minimum	0
5-th percentile	1
Q1	1
median	3
Q3	13
95-th percentile	23
Maximum	24
Range	24
Interquartile range (IQR)	12

Descriptive statistics

Standard deviation	7.123063358
Coefficient of variation (CV)	1.009790666
Kurtosis	-0.4649431463
Mean	7.054
Median Absolute Deviation (MAD)	2
Skewness	0.9391620349
Sum	35270
Variance	50.73803161
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=25)

Value	Count	Frequency (%)
1	1263	25.3%
2	747	14.9%
3	406	8.1%
4	231	4.6%
5	224	4.5%
16	210	4.2%
13	180	3.6%
12	176	3.5%
23	160	3.2%
0	157	3.1%
Other values (15)	1246	24.9%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	157	3.1%
1	1263	25.3%
2	747	14.9%
3	406	8.1%
4	231	4.6%
5	224	4.5%
6	107	2.1%
7	62	1.2%
8	84	1.7%
9	98	2.0%

Value	Count	Frequency (%)
24	101	2.0%
23	160	3.2%
22	38	0.8%
21	23	0.5%
20	55	1.1%
19	115	2.3%
18	77	1.5%
17	104	2.1%
16	210	4.2%
15	138	2.8%

order_prep_time
Real number (ℝ)

ZEROS

Distinct	29
Distinct (%)	0.6%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	1.3848

Minimum	-15
Maximum	22
Zeros	2063
Zeros (%)	41.3%
Negative	20
Negative (%)	0.4%
Memory size	39.2 KiB

Quantile statistics

Minimum	-15
5-th percentile	0
Q1	0
median	1
Q3	2
95-th percentile	5
Maximum	22
Range	37
Interquartile range (IQR)	2

Descriptive statistics

Standard deviation	2.260121809
Coefficient of variation (CV)	1.632092583
Kurtosis	17.51197933
Mean	1.3848
Median Absolute Deviation (MAD)	1
Skewness	1.997600968
Sum	6924
Variance	5.10815059
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=29)

Value	Count	Frequency (%)
0	2063	41.3%
1	1429	28.6%
2	457	9.1%
3	410	8.2%
4	324	6.5%
5	92	1.8%
7	75	1.5%
6	37	0.7%
8	27	0.5%
10	19	0.4%
Other values (19)	67	1.3%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
-15	3	0.1%
-14	3	0.1%
-13	4	0.1%
-10	1	< 0.1%
-8	3	0.1%
-7	3	0.1%
-6	2	< 0.1%
-2	1	< 0.1%
0	2063	41.3%
1	1429	28.6%

Value	Count	Frequency (%)
22	2	< 0.1%
19	6	0.1%
18	1	< 0.1%
17	1	< 0.1%
16	6	0.1%
15	2	< 0.1%
14	6	0.1%
13	1	< 0.1%
12	8	0.2%
11	6	0.1%

order_delivery_time
Real number (ℝ_≥0)

HIGH CORRELATION
ZEROS

Distinct	21
Distinct (%)	0.4%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	1.9474

Minimum	0
Maximum	23
Zeros	2212
Zeros (%)	44.2%
Negative	0
Negative (%)	0.0%
Memory size	39.2 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	1
Q3	4
95-th percentile	5
Maximum	23
Range	23
Interquartile range (IQR)	4

Descriptive statistics

Standard deviation	2.45019059
Coefficient of variation (CV)	1.258185576
Kurtosis	10.86742105
Mean	1.9474
Median Absolute Deviation (MAD)	1
Skewness	2.318136007
Sum	9737
Variance	6.003433927
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=21)

Value	Count	Frequency (%)
0	2212	44.2%
2	736	14.7%
4	681	13.6%
3	462	9.2%
5	338	6.8%
1	329	6.6%
6	71	1.4%
7	57	1.1%
8	37	0.7%
11	14	0.3%
Other values (11)	63	1.3%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	2212	44.2%
1	329	6.6%
2	736	14.7%
3	462	9.2%
4	681	13.6%
5	338	6.8%
6	71	1.4%
7	57	1.1%
8	37	0.7%
9	12	0.2%

Value	Count	Frequency (%)
23	4	0.1%
22	2	< 0.1%
18	2	< 0.1%
17	5	0.1%
16	4	0.1%
15	7	0.1%
14	7	0.1%
13	9	0.2%
12	1	< 0.1%
11	14	0.3%

order_total_time
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
ZEROS

Distinct	46
Distinct (%)	0.9%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	10.3862

Minimum	0
Maximum	48
Zeros	157
Zeros (%)	3.1%
Negative	0
Negative (%)	0.0%
Memory size	39.2 KiB

Quantile statistics

Minimum	0
5-th percentile	1
Q1	4
median	8
Q3	16
95-th percentile	26
Maximum	48
Range	48
Interquartile range (IQR)	12

Descriptive statistics

Standard deviation	8.115480378
Coefficient of variation (CV)	0.7813714716
Kurtosis	0.4843135273
Mean	10.3862
Median Absolute Deviation (MAD)	5
Skewness	0.9934974334
Sum	51931
Variance	65.86102176
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=46)

Value	Count	Frequency (%)
3	456	9.1%
4	390	7.8%
5	379	7.6%
2	308	6.2%
8	303	6.1%
6	303	6.1%
9	262	5.2%
7	260	5.2%
10	166	3.3%
23	159	3.2%
Other values (36)	2014	40.3%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	157	3.1%
1	132	2.6%
2	308	6.2%
3	456	9.1%
4	390	7.8%
5	379	7.6%
6	303	6.1%
7	260	5.2%
8	303	6.1%
9	262	5.2%

Value	Count	Frequency (%)
48	4	0.1%
47	2	< 0.1%
46	2	< 0.1%
45	1	< 0.1%
43	1	< 0.1%
41	1	< 0.1%
39	3	0.1%
38	2	< 0.1%
37	2	< 0.1%
36	4	0.1%

gm_estimated
Real number (ℝ)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION

Distinct	1520
Distinct (%)	30.4%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	37.399984

Minimum	-202.09
Maximum	604.5
Zeros	5
Zeros (%)	0.1%
Negative	121
Negative (%)	2.4%
Memory size	39.2 KiB

Quantile statistics

Minimum	-202.09
5-th percentile	7.039
Q1	20.3
median	31.41
Q3	42.14
95-th percentile	76.1
Maximum	604.5
Range	806.59
Interquartile range (IQR)	21.84

Descriptive statistics

Standard deviation	49.12753444
Coefficient of variation (CV)	1.313571002
Kurtosis	52.77797864
Mean	37.399984
Median Absolute Deviation (MAD)	10.78
Skewness	6.177480479
Sum	186999.92
Variance	2413.51464
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
42.14	81	1.6%
29.94	62	1.2%
37.3	47	0.9%
32.27	45	0.9%
29.51	37	0.7%
29.97	34	0.7%
33.06	33	0.7%
26.3	30	0.6%
18.45	28	0.6%
33.22	27	0.5%
Other values (1510)	4576	91.5%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
-202.09	1	< 0.1%
-124.93	2	< 0.1%
-124.28	2	< 0.1%
-124.01	2	< 0.1%
-116.31	1	< 0.1%
-111.47	2	< 0.1%
-111.07	1	< 0.1%
-109.27	2	< 0.1%
-100.23	1	< 0.1%
-98.62	2	< 0.1%

Value	Count	Frequency (%)
604.5	2	< 0.1%
586.02	2	< 0.1%
532.94	3	0.1%
483.09	2	< 0.1%
470.79	2	< 0.1%
468.91	1	< 0.1%
466.04	2	< 0.1%
455.05	2	< 0.1%
454.39	1	< 0.1%
451.94	4	0.1%

Spearman's ρ

The Spearman's rank correlation coefficient (ρ) is a measure of monotonic correlation between two variables, and is therefore better in catching nonlinear monotonic correlations than Pearson's r. It's value lies between -1 and +1, -1 indicating total negative monotonic correlation, 0 indicating no monotonic correlation and 1 indicating total positive monotonic correlation.

To calculate ρ for two variables X and Y, one divides the covariance of the rank variables of X and Y by the product of their standard deviations.

Pearson's r

The Pearson's correlation coefficient (r) is a measure of linear correlation between two variables. It's value lies between -1 and +1, -1 indicating total negative linear correlation, 0 indicating no linear correlation and 1 indicating total positive linear correlation. Furthermore, r is invariant under separate changes in location and scale of the two variables, implying that for a linear function the angle to the x-axis does not affect r.

To calculate r for two variables X and Y, one divides the covariance of X and Y by the product of their standard deviations.

Kendall's τ

Similarly to Spearman's rank correlation coefficient, the Kendall rank correlation coefficient (τ) measures ordinal association between two variables. It's value lies between -1 and +1, -1 indicating total negative correlation, 0 indicating no correlation and 1 indicating total positive correlation.

To calculate τ for two variables X and Y, one determines the number of concordant and discordant pairs of observations. τ is given by the number of concordant pairs minus the discordant pairs divided by the total number of pairs.

Cramér's V (φc)

Cramér's V is an association measure for nominal random variables. The coefficient ranges from 0 to 1, with 0 indicating independence and 1 indicating perfect association. The empirical estimators used for Cramér's V have been proved to be biased, even for large samples. We use a bias-corrected measure that has been proposed by Bergsma in 2013 that can be found here.

Phik (φk)

Phik (φk) is a new and practical correlation coefficient that works consistently between categorical, ordinal and interval variables, captures non-linear dependency and reverts to the Pearson correlation coefficient in case of a bivariate normal input distribution. There is extensive documentation available here.

A simple visualization of nullity by column.

Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.

The correlation heatmap measures nullity correlation: how strongly the presence or absence of one variable affects the presence of another.

The dendrogram allows you to more fully correlate variable completion, revealing trends deeper than the pairwise ones visible in the correlation heatmap.

First rows

	line_type	mkp_name	mkp_order_no	order_date	ordoro_id	sku	item_sale_price	shipping_sale	total_per_sku	title	supplier_name	order_status	item_cost	transport_cost_est	first_pick_date	last_delivery_date	courier	mage_mkp_commission	mkp_estimated_commission	mkp_actual_commission	order_grand_total	ordoro_import_date	tool_import_date	max_shipping_date	max_delivery_date	cd_status	is_clogistique_order	line_status	order_place_time	order_prep_time	order_delivery_time	order_total_time	gm_estimated
0	ORDER LINE	CDiscount	2009161727KUPJE	2020-09-16 15:27:00	1-300055647	KK-KKLJOYBLU00000	69.95	9.95	79.90	NaN	KK	shipped	0.00	0.0	0000-00-00 00:00:00	0000-00-00 00:00:00	NaN	1.92	0.00	13.90	81.82	2020-09-16 19:46:00	2020-09-16 19:51:00	2020-09-30	2020-10-09	WaitingForShipmentAcceptation	No	Awaiting shipment	16	0	0	16	51.08
1	ORDER LINE	CDiscount	2009161727KUPJE	2020-09-16 15:27:00	1-300055647	KK-KKLJOYBLU00000	69.95	9.95	79.90	NaN	KK	shipped	0.00	0.0	0000-00-00 00:00:00	0000-00-00 00:00:00	NaN	1.92	0.00	13.90	81.82	2020-09-16 19:46:00	2020-09-16 19:51:00	2020-09-30	2020-10-09	WaitingForShipmentAcceptation	No	Awaiting shipment	16	0	0	16	51.08
2	ORDER LINE	PriceMinister	322836927	2020-09-24 22:25:00	1-300056586	KK-KKWMOOVNAV0000	319.95	0.00	319.95	NaN	KK	shipped	171.00	0.0	0000-00-00 00:00:00	0000-00-00 00:00:00	NaN	0.00	47.99	0.00	319.95	2020-09-25 00:49:00	2020-09-25 00:51:00	2020-10-05	2020-10-08	NaN	No	Awaiting shipment	8	0	0	8	47.64
3	ORDER LINE	Monechelle	M200923734296	2020-09-25 08:47:00	1-300056600	KK-KKLJOYBLU000AC	79.95	0.00	79.95	NaN	KK	shipped	0.00	0.0	0000-00-00 00:00:00	0000-00-00 00:00:00	NaN	0.00	11.99	0.00	79.95	2020-09-25 12:02:00	2020-09-25 12:10:00	2020-10-02	2020-10-13	NaN	No	Awaiting shipment	8	0	0	8	54.64
4	ORDER LINE	Monechelle	M200923740097	2020-09-25 13:11:00	1-300056647	KK-KKLJOYBLU000AC	79.95	0.00	79.95	NaN	KK	shipped	0.00	0.0	0000-00-00 00:00:00	0000-00-00 00:00:00	NaN	0.00	11.99	0.00	79.95	2020-09-25 15:22:00	2020-09-25 15:30:00	2020-10-02	2020-10-13	NaN	No	Awaiting shipment	7	0	0	7	54.64
5	ORDER LINE	Monechelle	M200923816976	2020-09-28 16:05:00	1-300057121	KK-KKKFINIBLK0000	119.95	0.00	119.95	NaN	KK	shipped	0.00	0.0	0000-00-00 00:00:00	0000-00-00 00:00:00	NaN	0.00	17.99	0.00	119.95	2020-09-28 18:36:00	2020-09-28 18:45:00	2020-10-05	2020-10-14	NaN	No	Awaiting shipment	4	0	0	4	81.97
6	ORDER LINE	Monechelle	M200923816976	2020-09-28 16:05:00	1-300057121	KK-KKKFINIBLK0000	119.95	0.00	119.95	NaN	KK	shipped	0.00	0.0	0000-00-00 00:00:00	0000-00-00 00:00:00	NaN	0.00	17.99	0.00	119.95	2020-09-28 18:36:00	2020-09-28 18:45:00	2020-10-05	2020-10-14	NaN	No	Awaiting shipment	4	0	0	4	81.97
7	ORDER LINE	CDiscount	20092821212SYQB	2020-09-28 19:21:00	1-300057167	KK-KKFJUFIBLK0000	79.95	9.95	89.90	NaN	KK	shipped	0.00	0.0	0000-00-00 00:00:00	0000-00-00 00:00:00	NaN	0.00	0.00	13.48	89.90	2020-09-28 22:19:00	2020-09-28 22:30:00	2020-10-12	2020-10-21	WaitingForShipmentAcceptation	No	Awaiting shipment	4	0	0	4	61.44
8	ORDER LINE	CDiscount	20092821212SYQB	2020-09-28 19:21:00	1-300057167	KK-KKFJUFIBLK0000	79.95	9.95	89.90	NaN	KK	shipped	0.00	0.0	0000-00-00 00:00:00	0000-00-00 00:00:00	NaN	0.00	0.00	13.48	89.90	2020-09-28 22:19:00	2020-09-28 22:30:00	2020-10-12	2020-10-21	WaitingForShipmentAcceptation	No	Awaiting shipment	4	0	0	4	61.44
9	ORDER LINE	CDiscount	20090822540NKZH	2020-09-08 20:54:00	1-300054777	AKO-K120-6SZ-BIALA	124.95	19.95	144.90	NaN	AKO	shipped	39.16	16.0	2020-09-10 11:15:00	0000-00-00 00:00:00	UPS	0.00	0.00	21.73	144.90	2020-09-09 00:33:00	2020-09-09 00:45:00	2020-09-23	2020-10-02	WaitingForShipmentAcceptation	No	Awaiting shipment	24	1	23	48	43.86

Last rows

	line_type	mkp_name	mkp_order_no	order_date	ordoro_id	sku	item_sale_price	shipping_sale	total_per_sku	title	supplier_name	order_status	item_cost	transport_cost_est	first_pick_date	last_delivery_date	courier	mage_mkp_commission	mkp_estimated_commission	mkp_actual_commission	order_grand_total	ordoro_import_date	tool_import_date	max_shipping_date	max_delivery_date	cd_status	is_clogistique_order	line_status	order_place_time	order_prep_time	order_delivery_time	order_total_time	gm_estimated
4990	ORDER LINE	Monechelle	M200923366641	2020-09-09 08:03:00	1-300054799	VOX-4011330	751.95	0.00	751.95	NaN	VOX	awaiting_fulfillment	231.00	145.00	0000-00-00 00:00:00	0000-00-00 00:00:00	NaN	0.00	112.79	0.00	751.95	2020-09-09 09:52:00	2020-09-09 10:00:00	2020-09-16	2020-09-25	NaN	No	Awaiting Protocol	24	0	0	24	137.84
4991	ORDER LINE	CDiscount	2009102124W8UBM	2020-09-10 19:24:00	1-300055026	VOX-5010521	79.95	9.95	89.90	NaN	VOX	shipped	37.00	16.00	0000-00-00 00:00:00	0000-00-00 00:00:00	NaN	0.00	0.00	13.48	89.90	2020-09-10 23:42:00	2020-09-10 23:45:00	2020-09-24	2020-10-05	WaitingForShipmentAcceptation	No	Awaiting shipment	22	0	0	22	8.44
4992	ORDER LINE	CDiscount	20092319183OWKB	2020-09-23 17:18:00	1-300056455	VOX-4013666	129.95	19.95	149.90	NaN	VOX	awaiting_fulfillment	43.00	35.85	0000-00-00 00:00:00	0000-00-00 00:00:00	DPD	3.59	0.00	26.07	153.49	2020-09-23 21:07:00	2020-09-23 21:10:00	2020-10-07	2020-10-16	WaitingForShipmentAcceptation	No	Awaiting Protocol	4	5	0	9	17.01
4993	ORDER LINE	CDiscount	20092416353KX8G	2020-09-24 14:35:00	1-300056540	VOX-4010752	198.95	19.95	218.90	NaN	VOX	awaiting_fulfillment	84.00	32.01	0000-00-00 00:00:00	0000-00-00 00:00:00	DPD	0.00	0.00	32.83	218.90	2020-09-24 18:48:00	2020-09-24 18:51:00	2020-10-08	2020-10-19	WaitingForShipmentAcceptation	No	Awaiting Protocol	3	5	0	8	33.58
4994	ORDER LINE	conforama	4913779302-A	2020-10-01 18:30:00	1-300057705	VOX-5010418	540.95	19.95	560.90	NaN	VOX	awaiting_fulfillment	141.00	145.00	0000-00-00 00:00:00	0000-00-00 00:00:00	NaN	0.00	91.96	0.00	560.90	2020-10-02 00:23:00	2020-10-02 00:30:00	2020-10-15	2020-10-26	NaN	No	Awaiting Protocol	1	0	0	1	89.46
4995	ORDER LINE	Monechelle	M201023911286	2020-10-02 08:57:00	1-300057740	VOX-5010521	89.95	0.00	89.95	NaN	VOX	awaiting_fulfillment	37.00	10.07	0000-00-00 00:00:00	0000-00-00 00:00:00	NaN	0.00	13.49	0.00	89.95	2020-10-02 11:45:00	2020-10-02 11:46:00	2020-10-09	2020-10-20	NaN	No	Awaiting Protocol	1	0	0	1	14.40
4996	ORDER LINE	CDiscount	2009111343V40SI	2020-09-11 11:43:00	1-300055062	TO-SZAFKA-S33-BIEL-MAT	67.85	9.95	77.80	NaN	TO	shipped	23.98	0.00	2020-09-24 21:18:00	2020-09-29 21:22:00	DPD	0.00	0.00	11.67	77.80	2020-09-11 15:11:00	2020-09-11 15:15:00	2020-09-25	2020-10-06	WaitingForShipmentAcceptation	No	Awaiting shipment	11	1	5	17	29.18
4997	ORDER LINE	Monechelle	M200923492535	2020-09-14 15:44:00	1-300055403	TO-SZAFKA-S33-BIEL-MAT	79.95	0.00	79.95	NaN	TO	shipped	23.98	0.00	2020-09-24 21:15:00	2020-09-30 18:49:00	DPD	0.00	11.99	0.00	79.95	2020-09-14 18:16:00	2020-09-14 18:30:00	2020-09-21	2020-09-30	NaN	No	Awaiting shipment	8	1	5	14	30.66
4998	ORDER LINE	CDiscount	2009210907BZSN1	2020-09-21 07:07:00	1-300056153	TO-SZAFKA-S33-BIEL-MAT	69.95	9.95	79.90	NaN	TO	shipped	23.98	0.00	2020-09-24 21:18:00	2020-09-29 16:27:00	DPD	0.00	0.00	11.98	79.90	2020-09-21 10:53:00	2020-09-21 11:00:00	2020-10-05	2020-10-14	WaitingForShipmentAcceptation	No	Awaiting shipment	2	1	4	7	30.62
4999	ORDER LINE	CDiscount	2009210907BZSN1	2020-09-21 07:07:00	1-300056153	TO-SZAFKA-S33-BIEL-MAT	69.95	9.95	79.90	NaN	TO	shipped	23.98	0.00	2020-09-24 21:18:00	2020-09-29 16:27:00	DPD	0.00	0.00	11.98	79.90	2020-09-21 10:53:00	2020-09-21 11:00:00	2020-10-05	2020-10-14	WaitingForShipmentAcceptation	No	Awaiting shipment	2	1	4	7	30.62

Most frequently occurring

	line_type	mkp_name	order_date	ordoro_id	sku	item_sale_price	shipping_sale	total_per_sku	supplier_name	order_status	item_cost	transport_cost_est	courier	mage_mkp_commission	mkp_actual_commission	order_grand_total	ordoro_import_date	tool_import_date	max_shipping_date	max_delivery_date	cd_status	is_clogistique_order	line_status	order_place_time	order_prep_time	order_delivery_time	order_total_time	gm_estimated	# duplicates
23	ORDER LINE	CDiscount	2020-09-09 13:38:00	1-300054839	TOP-R40/black	57.95	9.95	67.90	TOP	shipped	18.43	15.95	DPD	1.63	11.82	278.12	2020-09-09 16:42:00	2020-09-09 16:45:00	2020-09-23	2020-10-02	Shipped	No	Awaiting shipment	23	1	7	31	9.03	8
14	ORDER LINE	CDiscount	2020-09-09 09:52:00	1-300054812	TOP-S33/sonoma	68.95	9.95	78.90	TOP	shipped	23.98	15.95	DPD	1.89	13.73	161.58	2020-09-09 13:15:00	2020-09-09 13:30:00	2020-09-23	2020-10-02	Shipped	No	Awaiting shipment	24	1	4	29	10.52	4
25	ORDER LINE	CDiscount	2020-09-09 13:52:00	1-300054843	TOP-KaroK2/sonoma	49.95	13.28	63.23	TOP	shipped	16.82	13.67	UPS	2.24	16.22	286.42	2020-09-09 16:42:00	2020-09-09 16:45:00	2020-09-23	2020-10-02	Shipped	No	Awaiting shipment	23	0	4	27	4.12	4
38	ORDER LINE	CDiscount	2020-09-09 16:33:00	1-300054874	AKO-K140-10SZ-BIALA	224.95	19.95	244.90	AKO	shipped	69.57	16.00	UPS	0.00	36.74	489.80	2020-09-09 19:59:00	2020-09-09 20:00:00	2020-10-14	2020-10-23	WaitingForShipmentAcceptation	No	Awaiting shipment	14	4	5	23	81.77	4
52	ORDER LINE	CDiscount	2020-09-09 20:38:00	1-300054909	AKO-BIURKO-PIN-BIALE	79.95	9.95	89.90	AKO	shipped	28.43	15.95	DPD	0.00	13.49	179.80	2020-09-09 23:24:00	2020-09-09 23:30:00	2020-09-23	2020-10-02	Shipped	No	Awaiting shipment	23	0	4	27	17.05	4
112	ORDER LINE	CDiscount	2020-09-17 09:25:00	1-300055713	TOP-S30/sonoma	66.95	9.95	76.90	TOP	shipped	23.08	15.95	DPD	0.00	11.54	153.80	2020-09-17 12:13:00	2020-09-17 12:15:00	2020-10-01	2020-10-12	WaitingForShipmentAcceptation	No	Awaiting shipment	16	4	3	23	13.51	4
146	ORDER LINE	CDiscount	2020-09-18 10:33:00	1-300055818	AKO-K60-6SZ-BIALA-POLYSK	219.95	19.95	239.90	AKO	shipped	80.30	16.00	UPS	5.76	41.74	491.31	2020-09-18 14:04:00	2020-09-18 14:10:00	2020-10-02	2020-10-13	WaitingForShipmentAcceptation	No	Awaiting shipment	2	3	5	10	57.08	4
192	ORDER LINE	CDiscount	2020-09-20 05:45:00	1-300056015	TOP-MalwaM6/140/white	114.95	34.95	149.90	TOP	shipped	43.95	16.00	UPS	11.40	23.84	277.00	2020-09-20 09:11:00	2020-09-20 09:15:00	2020-10-05	2020-10-14	WaitingForShipmentAcceptation	No	Awaiting shipment	13	3	7	23	31.63	4
223	ORDER LINE	CDiscount	2020-09-20 18:42:00	1-300056117	TOP-MalwaM6/140/sonoma	114.95	19.95	134.90	TOP	shipped	43.95	16.00	UPS	0.00	20.24	269.80	2020-09-20 21:44:00	2020-09-20 21:45:00	2020-10-02	2020-10-13	WaitingForShipmentAcceptation	No	Awaiting shipment	12	2	5	19	32.23	4
263	ORDER LINE	CDiscount	2020-09-27 13:40:00	1-300056941	AKO-K120-6SZ-BIALA	89.95	19.95	109.90	AKO	shipped	39.16	0.00	UPS	2.64	11.43	225.08	2020-09-27 18:15:00	2020-09-27 18:30:00	2020-10-09	2020-10-20	WaitingForShipmentAcceptation	No	Awaiting shipment	5	1	3	9	38.79	4

Overview

Variables

Common Values

Length

Category Frequency Plot

Most occurring characters

Most occurring categories

Most frequent character per category

Uppercase Letter

Space Separator

Most occurring scripts

Most frequent character per script

Latin

Common

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Category Frequency Plot

Most occurring characters

Most occurring categories

Most frequent character per category

Lowercase Letter

Uppercase Letter

Most occurring scripts

Most frequent character per script

Latin

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Most occurring characters

Most occurring categories

Most frequent character per category

Decimal Number

Dash Punctuation

Most occurring scripts

Most frequent character per script

Common

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Most occurring characters

Most occurring categories

Most frequent character per category

Uppercase Letter

Lowercase Letter

Decimal Number

Other Punctuation

Dash Punctuation

Connector Punctuation

Space Separator

Most occurring scripts

Most frequent character per script

Latin

Common

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Category Frequency Plot

Most occurring characters

Most occurring categories

Most frequent character per category

Decimal Number

Most occurring scripts

Most frequent character per script

Common

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Most occurring characters

Most occurring categories